package com.bw.mapper;

import com.bw.bean.OrderInfo;
import com.bw.bean.Vo;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.util.List;

/**
* @author 25199
* @description 针对表【order_info(物流单表)】的数据库操作Mapper
* @createDate 2025-04-11 08:27:01
* @Entity com.bw.bean.OrderInfo
*/
@Mapper
public interface OrderInfoMapper {

    @Select("select b.name,count(oi.id) value from base_province b\n" +
            "left join order_info oi on b.id = oi.province_id\n" +
            "group by b.name")
    List<Vo> cx1();

    @Select("select cargo_type name ,count(order_id) value from order_cargo group by cargo_type")
    List<Vo> cx2();

    @Select("call p1()")
    Double cx3();
}




